<?php
class matchmodel extends model{
	    public function matchlist(){
		$sql="select m.teamone,t1.team as team1,m.score,m.teamtwo,t2.team as team2 from `match` as m
		left join team as t1 on m.teamone=t1.id
		left join team as t2 on m.teamtwo=t2.id";
		return  $this->db->qurey($sql);

	}
}
?>